| Tips, Tricks and Utilities |
|
| |
1. Function
to remove symbols from a string |
| |
2. Function to
validate a date |
| |
3. Function
to validate a number |
| |
4. Credit
card validation based on LUHN algorithm |
| |
5. U.S.
Bank ABA number validation |
| |
6. Format a
Social Security Number |
| |
7. Format
a US Postal Code |
| |
8. Function
to count incidence of a specific char string |
| |
9. Function
to count the number of words in a string |
| |
10. Function
to return the phone number for a string of characters |
| |
11. Function
to strip extra spaces in a string |
| |
12. PLSQL
implementation of Lawrence Philips' Metaphone algorithm See
Also |
| |
13. Send
e-mail messages from PL/SQL with MIME attachments (Virgilio
Nunes) |
| |
14. Function
that returns the words for currency (good for checks) |
| |
15. Pre-Defined
Exceptions for use in PL/SQL code (w/example) |
| |
16. Error
Stack Dump routine (writes to file) |
| |
17. User
Password Change routines |
| |
18. UTL_FILE
Load routine |
| |
19. Word Wrap
routine |
| |
20. Simple
if-then-else function for use in SQL |
| |
21. Schema
Template Code Generator. |
| |
22. DBMS Job
Control System |
| |
23. Sample
Advanced Queueing code |
| |
24. Get Field
from a delimited string of data |
| |
25. Determine
if the string has legible characters |
| |
26. Random
date generator, good for building test data!! |
| |
27. Address
Line clean-up routine |
| |
28. Phone
Number clean-up routine |
| |
|
| |
Links to Other PL/SQL resources |
| |
DMOZ PL/SQL
Directory (Search Site) |
